package com.yenlien.traceyun.business.dao;

import com.yenlien.traceyun.business.entity.ClientOrder;
import com.yenlien.traceyun.webase.dao.BaseJpaDao;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @author: bigwangy@sina.com
 * @create: 2020-12-08
 * @description:
 **/
public interface ClientOrderDao extends BaseJpaDao<ClientOrder> {


    @Query(value = "SELECT COUNT(id) FROM t_clientorder WHERE company_id = ?1", nativeQuery = true)
    String orderNumCount(String companyId);

    public List<ClientOrder> findByClientId(String clientId);


}
